{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Control","AUX2","Net42","Net41","Net32","Net31","Net22","Net21","Net12","Net11","AUX","specs"],"not_rendered":{"charts":0,"images":555,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Control","index":0,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,"PS actual power"]
[null,null,null,null,"T-Former:  935 W"]
[null,null,null,null,"Ferro:  987 W"]

{"sheet":"AUX2","index":1,"n_rows":54,"n_cols":22,"rows_kept":54,"cut":false,"hidden":true,"merged":[[3,15,3,16],[47,0,52,11]]}
[{"$f":"'Net42'!B1+'Net41'!B1+'Net32'!B1+'Net31'!B1+'Net22'!B1+'Net21'!B1+'Net12'!B1+'Net11'!B1+SUM(A7:A18)","v":0},"Vtriac(vba)",1.5,{"$f":"+'Net11'!D1+'Net12'!D1+'Net21'!D1+'Net22'!D1+'Net31'!D1+'Net32'!D1+'Net41'!D1+'Net42'!D1","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,"66V","V0",1]
[null,null,{"$f":"+C5*1","v":66},null,null,null,null,null,null,"m",null,null,null,null,null,null,null,null,61.801889953100932,"61.8V","V01",2]
[null,null,null,null,null,null,null,null,null,"ft",null,null,null,null,null,null,null,null,62.216907556662285,"62.2V","V02",3]
[1.32,null,null,"V","m","i temp","i","drop","k","dist","L","cable","Vinput",1E-4,null,null,null,null,63.09176371484731,"63.1V","V03",4]
["PS - Imax Vout",15,"66","V","-","A","A","V","-","m","km",null,"V","accuracy",null,null,null,null,63.091824122148871,"63.1V","V04",5]
["Vmin amp.",44,{"$f":"IF(C2=60,66,90)","v":90},63.09176371484731,null,null,null,null,null,null,null,null,null,{"$f":"ABS(SUM(N7:N14))","v":9.7496580622191686E-6},null,null,null,null,2.0154312527260698,"2A","I01",6]
[{"$f":"IF(D7<0,1,0)","v":0},7,11,{"$f":"+D15-H7","v":61.801889953100932},1,{"$f":"+'Net11'!D2","v":1.0055835398607509},{"$f":"+F7*E7","v":1.0055835398607509},{"$f":"+G7*K7*VLOOKUP(L7,specs!$K$5:$L$19,2)","v":0},1,0,{"$f":"+IF($J$5=\"m\",J7,(J7*0.3048))/1000*I7","v":0},"cable",61.801887044733476,{"$f":"E7*(+M7-D7)","v":-2.908367456200267E-6},null,null,null,null,3.0125900763947113,"3A","I02",7]
[0,8,12,{"$f":"+D15-H8","v":61.801889953100932},1,{"$f":"+'Net12'!D2","v":1.0098477128653189},{"$f":"+F8*E8","v":1.0098477128653189},{"$f":"+G8*K8*VLOOKUP(L8,specs!$K$5:$L$19,2)","v":0},1,0,{"$f":"+IF($J$5=\"m\",J8,(J8*0.3048))/1000*I8","v":0},"cable",61.801887044733476,{"$f":"E8*(+M8-D8)","v":-2.908367456200267E-6},null,null,null,null,6.2454247353160932,"6.2A","I03",8]
[0,9,21,{"$f":"+D16-H9","v":62.216907556662285},1,{"$f":"+'Net21'!D2","v":0.49869586025072199},0.49869586025072199,{"$f":"+G9*K9*VLOOKUP(L9,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",62.21690559020071,-1.9664615749093173E-6,null,null,null,null,13.346169504977285,"13.3A","I04",9]
[0,10,22,{"$f":"+D16-H10","v":62.216907556662285},1,{"$f":"+'Net22'!D2","v":0.49846296341791985},0.49846296341791985,{"$f":"+G10*K10*VLOOKUP(L10,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",62.21690559020071,-1.9664615749093173E-6,null,null,null,null,61.801889953100932,"61.8V","V11",10]
[0,11,31,{"$f":"+D17-H11","v":63.09176371484731},1,{"$f":"+'Net31'!D2","v":0.49699781349123329},0.49699781349123329,{"$f":"+G11*K11*VLOOKUP(L11,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",63.09176371484731,0,null,null,null,null,61.801889953100932,"61.8V","V12",11]
[0,12,32,{"$f":"+D17-H12","v":63.09176371484731},1,{"$f":"+'Net32'!D2","v":2.7358368454301485},2.7358368454301485,{"$f":"+G12*K12*VLOOKUP(L12,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",63.09176371484731,0,null,null,null,null,62.216907556662285,"62.2V","V21",12]
[0,13,41,{"$f":"+D18-H13","v":63.09176371484731},1,{"$f":"+'Net41'!D2","v":0.99606742089744515},0.99606742089744515,{"$f":"+G13*K13*VLOOKUP(L13,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",63.09176371484731,0,null,null,null,null,62.216907556662285,"62.2V","V22",13]
[0,14,42,{"$f":"+D18-H14","v":63.09176371484731},1,{"$f":"+'Net42'!D2","v":2.3406365906802584},2.3406365906802584,{"$f":"+G14*K14*VLOOKUP(L14,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",63.09176371484731,0,null,null,null,null,63.09176371484731,"63.1V","V31",14]
[{"$f":"IF(D15<0,1,0)","v":0},15,"01",{"$f":"+D16-H15","v":61.801889953100932},1,{"$f":"SUM(F7:F8)","v":2.0154312527260698},{"$f":"+F15*E15","v":2.0154312527260698},{"$f":"+G15*K15*VLOOKUP(L15,specs!$K$5:$L$19,2)","v":0.41501760356135237},1,"39",{"$f":"+IF($J$5=\"m\",J15,(J15*0.3048))/1000*I15","v":3.9E-2},"QR540",{"$f":"K15*VLOOKUP(L15,specs!$K$5:$L$19,2)","v":0.20592000000000002},null,null,null,null,null,63.09176371484731,"63.1V","V32",15]
[{"$f":"IF(D16<0,1,0)","v":0},16,"02",{"$f":"+D17-H16","v":62.216907556662285},1,{"$f":"SUM(F7:F10)","v":3.0125900763947113},{"$f":"+F16*E16","v":3.0125900763947113},{"$f":"+G16*K16*VLOOKUP(L16,specs!$K$5:$L$19,2)","v":0.87485615818502416},1,"55",{"$f":"+IF($J$5=\"m\",J16,(J16*0.3048))/1000*I16","v":5.5E-2},"QR540",{"$f":"K16*VLOOKUP(L16,specs!$K$5:$L$19,2)","v":0.29039999999999999},null,null,null,null,null,63.09176371484731,"63.1V","V41",16]
[{"$f":"IF(D17<0,1,0)","v":0},17,"03",{"$f":"+D18-H17","v":63.09176371484731},1,{"$f":"SUM(F7:F12)","v":6.2454247353160932},{"$f":"+F17*E17","v":6.2454247353160932},{"$f":"+G17*K17*VLOOKUP(L17,specs!$K$5:$L$19,2)","v":0},1,0,{"$f":"+IF($J$5=\"m\",J17,(J17*0.3048))/1000*I17","v":0},"cable",{"$f":"K17*VLOOKUP(L17,specs!$K$5:$L$19,2)","v":0},null,null,null,null,null,63.09176371484731,"63.1V","V42",17]
[{"$f":"IF(D18<0,1,0)","v":0},18,"04",{"$f":"+D6-H18","v":63.09176371484731},0,{"$f":"SUM(F7:F14)","v":9.5821287468937975},{"$f":"+F18*E18","v":0},{"$f":"+G18*K18*VLOOKUP(L18,specs!$K$5:$L$19,2)","v":0},1,"600",{"$f":"+IF($J$5=\"m\",J18,(J18*0.3048))/1000*I18","v":0.6},"QR860",{"$f":"K18*VLOOKUP(L18,specs!$K$5:$L$19,2)","v":1.4219999999999999},null,null,null,null,null,1.0055835398607509,"1A","I11",18]
[null,null,null,null,null,null,null,"D6:L18",null,null,null,null,null,null,null,null,null,null,1.0098477128653189,"1A","I12",19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.49869586025072199,".5A","I21",20]
[null,"Booster Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.49846296341791985,".5A","I22",21]
[null,null,"vba","vba","vba",null,null,null,null,null,null,null,null,null,null,null,null,null,0.49699781349123329,".5A","I31",22]
["Vin","Ranges","Mcont","TrEff","Bgain","Vout","Pin","Iin","Final Gain ","Efficiency","P-triac ","P-transformer ","Pout","Iout",null,null,null,null,2.7358368454301485,"2.7A","I32",23]
[62,"57.5-66",1,97,1.0329999999999999,{"$f":"A24*E24/C24-1.5","v":62.545999999999992},{"$f":"M24+L24+K24","v":204.99446979822852},{"$f":"G24/A24","v":3.3063624161004599},{"$f":"F24/A24","v":1.0088064516129032},{"$f":"M24/G24","v":0.97563607543586683},{"$f":"N24*1.5","v":4.7964697982285038},{"$f":"M24*(E24-1)*0.03","v":0.19799999999999951},200,{"$f":"M24/F24","v":3.1976465321523362},null,null,null,null,0.99606742089744515,"1A","I41",24]
[57.5,"49.9-57.5",1.0249999999999999,96.8,1.2110000000000001,{"$f":"A25*E25/C25-1.5","v":66.434146341463432},{"$f":"M25+L25+K25","v":205.86615005507014},{"$f":"G25/A25","v":3.5802808705229587},{"$f":"F25/A25","v":1.1553764581124075},{"$f":"M25/G25","v":0.97150502861446175},{"$f":"N25*1.5","v":4.5157500550701215},{"$f":"M25*(E25-1)*0.032","v":1.3504000000000005},200,{"$f":"M25/F25","v":3.0105000367134145},null,null,null,null,2.3406365906802584,"2.3A","I42",25]
[49.9,"0-49.9",1.0249999999999999,96.5,1.4079999999999999,{"$f":"A26*E26/C26-1.5","v":67.04556097560976},{"$f":"M26+L26+K26","v":207.33056916810847},{"$f":"G26/A26","v":4.1549212258137969},{"$f":"F26/A26","v":1.3435984163448851},{"$f":"M26/G26","v":0.96464308568909263},{"$f":"N26*1.5","v":4.4745691681084718},{"$f":"M26*(E26-1)*0.035","v":2.8559999999999994},200,{"$f":"M26/F26","v":2.9830461120723148},null,null,null,null,61.261731759742425,"61.3V","Vend11",26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61.052050041418759,"61.1V","Vend12",27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61.961613205421159,"62V","Vend21",28]
["Vin",null,null,null,null,"Vout","Pin","Iin",null,"Efficiency","P-triac ","P-transformer ","Pout","Iout",null,null,null,null,61.990563527771904,"62V","Vend22",29]
[83,"74.9-90",1,97,1.048,{"$f":"A30*E30/C30-1.5","v":85.484000000000009},{"$f":"M30+L30+K30","v":203.79742866501334},{"$f":"G30/A30","v":2.4553907068073895},{"$f":"F30/A30","v":1.0299277108433735},{"$f":"M30/G30","v":0.9813666507478106},{"$f":"N30*1.5","v":3.5094286650133357},{"$f":"M30*(E30-1)*0.03","v":0.28800000000000026},200,{"$f":"M30/F30","v":2.3396191100088903},null,null,null,null,62.173311755515513,"62.2V","Vend31",30]
[74.900000000000006,"62-74.9",1.0249999999999999,96.8,1.2789999999999999,{"$f":"A31*E31/C31-1.5","v":91.96058536585366},{"$f":"M31+L31+K31","v":205.04786718551742},{"$f":"G31/A31","v":2.737621724773263},{"$f":"F31/A31","v":1.2277781757790875},{"$f":"M31/G31","v":0.97538200589548019},{"$f":"N31*1.5","v":3.2622671855174432},{"$f":"M31*(E31-1)*0.032","v":1.7855999999999994},200,{"$f":"M31/F31","v":2.1748447903449621},null,null,null,null,55.998384800640125,"56V","Vend32",31]
[61.9,"0-61.9",1.0249999999999999,96.5,1.538,{"$f":"A32*E32/C32-1.5","v":91.380195121951232},{"$f":"M32+L32+K32","v":207.04898708051164},{"$f":"G32/A32","v":3.3448947832069731},{"$f":"F32/A32","v":1.4762551715985659},{"$f":"M32/G32","v":0.96595497915780382},{"$f":"N32*1.5","v":3.2829870805116546},{"$f":"M32*(E32-1)*0.035","v":3.7660000000000005},200,{"$f":"M32/F32","v":2.1886580536744362},null,null,null,null,61.766573808315115,"61.8V","Vend41",32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61.850568234194483,"61.9V    ","Vend42",33]
["Pin = Pout + Ptriac + Pdelta-transformer, where",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47.021746963922297,"47V","PBVin",34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63.091824122148871,"63.1V","PBVout",35]
["Pout =  Vout x Iout;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.346169504977285,"13.3A","PBcurin",36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5821287468937975,"9.6A","PBcurout",37]
["Ptriac = Vtriac * Iout  , where   Vtriac=1.5V;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3417584032034462,1.34,"Bgain",38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PB Location I","STitleLocation",39]
["Pdelta-transformer = (100 - K) / 100 * (n – 1)  *  Pout  , where  K=96.5%  for range\"1.32\" , K=96.8% for range \"1.2\" and K=97% for range \"1\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V in","sTitleVin",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V out","sTitleVout",41]
["Then, assuming",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I in","STitleIin",42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I out","sTitleIout",43]
["Vout = Vin * n / Mcont  –  Vtriac ,  where Mcont = 1 for range\"1\", Mcont=1.025 for other two ranges;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gain","sTitleGain",44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"time",45]
["We get  finally the booster input current Iin, derived from above, as a function of the booster output current Iout and the booster input voltage Vin:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,null,"cntext",46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"cntloc",47]
["Iin = Iout * { Bgain / Mcont + (1 - TrEff / 100) * (Bgain – 1) * ( Bgain / Mcont – Vtriac*Mcont * (PBVout + Vtriac) / Bgain)}",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,null,"cntsum",48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntloc04",49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntsum04",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntloc03",51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntsum03",52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntloc02",53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntsum02",54]

{"sheet":"Net42","index":2,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M14","v":63.09176371484731},"U start, V",{"$f":"+O5*1","v":2.3406365906802584},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":64.308687881893107},{"$f":"G6+G5*G4","v":63.115551159078429},63.092237934198103,63.091773172416168,63.091763903465306,63.09176371860903,63.091763714922337,63.091763714848803,63.091763714847339,63.09176371484731]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(F6<67,(F6/1.03),65)*$E6+F8","v":2.2954935283155296},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(G6<67,(G6/1.03),65)*$E6+G8","v":2.3397369863763293},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(H6<67,(H6/1.03),65)*$E6+H8","v":2.340618649610501},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(I6<67,(I6/1.03),65)*$E6+I8","v":2.3406362328707551},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(J6<67,(J6/1.03),65)*$E6+J8","v":2.3406365835442471},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(K6<67,(K6/1.03),65)*$E6+K8","v":2.3406365905379407},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(L6<67,(L6/1.03),65)*$E6+L8","v":2.3406365906774198},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(M6<67,(M6/1.03),65)*$E6+M8","v":2.340636590680202},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(N6<67,(N6/1.03),65)*$E6+N8","v":2.3406365906802575},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(O6<67,(O6/1.03),65)*$E6+O8","v":2.3406365906802584}]
[null,null,"amplifier","TNA","1",{"$f":"F9+F8*F7","v":64.308687881893107},{"$f":"G9+G8*G7","v":63.115551159078429},63.092237934198103,63.091773172416168,63.091763903465306,63.09176371860903,63.091763714922337,63.091763714848803,63.091763714847339,63.09176371484731]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992}]
[null,null,"span length,m","89",0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(F9<67,(F9/1.03),65)*$E9+F11","v":1.4626356087391537},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(G9<67,(G9/1.03),65)*$E9+G11","v":1.4911347161528516},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(H9<67,(H9/1.03),65)*$E9+H11","v":1.4917028122001958},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(I9<67,(I9/1.03),65)*$E9+I11","v":1.4917141419725946},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(J9<67,(J9/1.03),65)*$E9+J11","v":1.4917143679290608},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(K9<67,(K9/1.03),65)*$E9+K11","v":1.4917143724354474},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(L9<67,(L9/1.03),65)*$E9+L11","v":1.4917143725253208},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(M9<67,(M9/1.03),65)*$E9+M11","v":1.4917143725271134},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(N9<67,(N9/1.03),65)*$E9+N11","v":1.4917143725271491},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(O9<67,(O9/1.03),65)*$E9+O11","v":1.4917143725271498}]
[null,null,"amplifier","LEX","1",{"$f":"F12+F11*F10","v":63.621366156634409},{"$f":"G12+G11*G10","v":62.41483713326388},62.391256948688984,62.390786862820406,62.390777487688084,62.390777300714163,62.390777296985235,62.390777296910862,62.390777296909384,62.390777296909356]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001}]
[null,null,"span length,m","38",0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(F12<67,(F12/1.03),65)*$E12+F14","v":0.97694971629973515},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(G12<67,(G12/1.03),65)*$E12+G14","v":0.99606012460942672},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(H12<67,(H12/1.03),65)*$E12+H14","v":0.99644111190439355},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(I12<67,(I12/1.03),65)*$E12+I14","v":0.99644871010778546},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(J12<67,(J12/1.03),65)*$E12+J14","v":0.99644886164333335},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(K12<67,(K12/1.03),65)*$E12+K14","v":0.99644886466549853},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(L12<67,(L12/1.03),65)*$E12+L14","v":0.99644886472577121},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(M12<67,(M12/1.03),65)*$E12+M14","v":0.99644886472697336},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(N12<67,(N12/1.03),65)*$E12+N14","v":0.99644886472699734},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(O12<67,(O12/1.03),65)*$E12+O14","v":0.99644886472699779}]
[null,null,"amplifier","LEX","1",{"$f":"F15+F14*F13","v":63.425350965556028},{"$f":"G15+G14*G13","v":62.214987629862243},62.191331003996488,62.190859393624379,62.190849988087962,62.190849800507678,62.190849796766656,62.190849796692042,62.190849796690557,62.190849796690529]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006}]
[null,null,"span length,m","129",0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(F15<67,(F15/1.03),65)*$E15+F17","v":0.48976281816525502},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(G15<67,(G15/1.03),65)*$E15+G17","v":0.49939523440910344},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(H15<67,(H15/1.03),65)*$E15+H17","v":0.49958729801810886},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(I15<67,(I15/1.03),65)*$E15+I17","v":0.49959112844253228},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(J15<67,(J15/1.03),65)*$E15+J17","v":0.49959120483499914},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(K15<67,(K15/1.03),65)*$E15+K17","v":0.49959120635854032},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(L15<67,(L15/1.03),65)*$E15+L17","v":0.49959120638892518},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(M15<67,(M15/1.03),65)*$E15+M17","v":0.49959120638953125},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(N15<67,(N15/1.03),65)*$E15+N17","v":0.4995912063895433},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(O15<67,(O15/1.03),65)*$E15+O17","v":0.49959120638954357}]
[null,null,"amplifier","LEX","1",{"$f":"F18+F17*F16","v":63.09176371484731},{"$f":"G18+G17*G16","v":61.874839547801514},61.851052103570396,61.850577884219604,61.850568426650746,61.85056823803275,61.85056823427103,61.850568234196004,61.850568234194512,61.850568234194483]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(F18<67,(F18/1.03),65)*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(G18<67,(G18/1.03),65)*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(H18<67,(H18/1.03),65)*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(I18<67,(I18/1.03),65)*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(J18<67,(J18/1.03),65)*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(K18<67,(K18/1.03),65)*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(L18<67,(L18/1.03),65)*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(M18<67,(M18/1.03),65)*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(N18<67,(N18/1.03),65)*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(O18<67,(O18/1.03),65)*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":63.09176371484731},{"$f":"G21+G20*G19","v":61.874839547801514},61.851052103570396,61.850577884219604,61.850568426650746,61.85056823803275,61.85056823427103,61.850568234196004,61.850568234194512,61.850568234194483]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(F21<67,(F21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(G21<67,(G21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(H21<67,(H21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(I21<67,(I21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(J21<67,(J21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(K21<67,(K21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(L21<67,(L21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(M21<67,(M21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(N21<67,(N21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(O21<67,(O21/1.03),65)","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":63.09176371484731},{"$f":"F21-(F3-$B$2)","v":61.874839547801514},61.851052103570396,61.850577884219604,61.850568426650746,61.85056823803275,61.85056823427103,61.850568234196004,61.850568234194512,61.850568234194483]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":61.850568234194483}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net42"]

{"sheet":"Net41","index":3,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M13","v":63.09176371484731},"U start, V",{"$f":"+O5*1","v":0.99606742089744515},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":64.389258251299609},{"$f":"G6+G5*G4","v":63.118868214089765},63.09234197417706,63.09177605717332,63.091763978283538,63.091763720470126,63.091763714967328,63.091763714849876,63.091763714847367,63.09176371484731]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001}]
[null,null,"span length,m","146",0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(F6<67,(F6/1.03),65)*$E6+F8","v":0.97532634909552096},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(G6<67,(G6/1.03),65)*$E6+G8","v":0.9956249683674715},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(H6<67,(H6/1.03),65)*$E6+H8","v":0.9960579772435012},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(I6<67,(I6/1.03),65)*$E6+I8","v":0.99606721933086417},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(J6<67,(J6/1.03),65)*$E6+J8","v":0.99606741659518061},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(K6<67,(K6/1.03),65)*$E6+K8","v":0.99606742080561694},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(L6<67,(L6/1.03),65)*$E6+L8","v":0.99606742089548495},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(M6<67,(M6/1.03),65)*$E6+M8","v":0.99606742089740319},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(N6<67,(N6/1.03),65)*$E6+N8","v":0.99606742089744427},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(O6<67,(O6/1.03),65)*$E6+O8","v":0.99606742089744515}]
[null,null,"amplifier","LEX","1",{"$f":"F9+F8*F7","v":63.637398675308859},{"$f":"G9+G8*G7","v":62.351360838474648},62.324500800679587,62.323927759135543,62.323915528178645,62.323915267119496,62.32391526154742,62.323915261428482,62.323915261425945,62.323915261425888]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002}]
[null,null,"span length,m","211",0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(F9<67,(F9/1.03),65)*$E9+F11","v":0.48976281816525502},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(G9<67,(G9/1.03),65)*$E9+G11","v":0.50004637017057718},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(H9<67,(H9/1.03),65)*$E9+H11","v":0.50026579915897063},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(I9<67,(I9/1.03),65)*$E9+I11","v":0.50027048265181828},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(J9<67,(J9/1.03),65)*$E9+J11","v":0.50027058261691237},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(K9<67,(K9/1.03),65)*$E9+K11","v":0.50027058475058095},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(L9<67,(L9/1.03),65)*$E9+L11","v":0.50027058479612219},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(M9<67,(M9/1.03),65)*$E9+M11","v":0.5002705847970943},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(N9<67,(N9/1.03),65)*$E9+N11","v":0.50027058479711506},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(O9<67,(O9/1.03),65)*$E9+O11","v":0.5002705847971155}]
[null,null,"amplifier","LEX","1",{"$f":"F12+F11*F10","v":63.09176371484731},{"$f":"G12+G11*G10","v":61.794269178395012},61.767164679152557,61.766586419822808,61.766574077496799,61.766573814060571,61.766573808437755,61.766573808317737,61.766573808315172,61.766573808315115]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(F12<67,(F12/1.03),65)*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(G12<67,(G12/1.03),65)*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(H12<67,(H12/1.03),65)*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(I12<67,(I12/1.03),65)*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(J12<67,(J12/1.03),65)*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(K12<67,(K12/1.03),65)*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(L12<67,(L12/1.03),65)*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(M12<67,(M12/1.03),65)*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(N12<67,(N12/1.03),65)*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(O12<67,(O12/1.03),65)*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":63.09176371484731},{"$f":"G15+G14*G13","v":61.794269178395012},61.767164679152557,61.766586419822808,61.766574077496799,61.766573814060571,61.766573808437755,61.766573808317737,61.766573808315172,61.766573808315115]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(F15<67,(F15/1.03),65)*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(G15<67,(G15/1.03),65)*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(H15<67,(H15/1.03),65)*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(I15<67,(I15/1.03),65)*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(J15<67,(J15/1.03),65)*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(K15<67,(K15/1.03),65)*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(L15<67,(L15/1.03),65)*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(M15<67,(M15/1.03),65)*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(N15<67,(N15/1.03),65)*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(O15<67,(O15/1.03),65)*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":63.09176371484731},{"$f":"G18+G17*G16","v":61.794269178395012},61.767164679152557,61.766586419822808,61.766574077496799,61.766573814060571,61.766573808437755,61.766573808317737,61.766573808315172,61.766573808315115]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(F18<67,(F18/1.03),65)*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(G18<67,(G18/1.03),65)*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(H18<67,(H18/1.03),65)*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(I18<67,(I18/1.03),65)*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(J18<67,(J18/1.03),65)*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(K18<67,(K18/1.03),65)*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(L18<67,(L18/1.03),65)*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(M18<67,(M18/1.03),65)*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(N18<67,(N18/1.03),65)*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(O18<67,(O18/1.03),65)*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":63.09176371484731},{"$f":"G21+G20*G19","v":61.794269178395012},61.767164679152557,61.766586419822808,61.766574077496799,61.766573814060571,61.766573808437755,61.766573808317737,61.766573808315172,61.766573808315115]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(F21<67,(F21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(G21<67,(G21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(H21<67,(H21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(I21<67,(I21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(J21<67,(J21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(K21<67,(K21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(L21<67,(L21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(M21<67,(M21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(N21<67,(N21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(O21<67,(O21/1.03),65)","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":63.09176371484731},{"$f":"F21-(F3-$B$2)","v":61.794269178395012},61.767164679152557,61.766586419822808,61.766574077496799,61.766573814060571,61.766573808437755,61.766573808317737,61.766573808315172,61.766573808315115]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":61.766573808315115}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net41"]

{"sheet":"Net32","index":4,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"'AUX2'!M12","v":63.09176371484731},"U start, V",{"$f":"+O5*1","v":2.7358368454301485},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":69.397571580352562},{"$f":"G6+G5*G4","v":63.782384045848623},63.176636028301928,63.102335161139614,63.093082657937593,63.091928306527834,63.091784254871648,63.091766278123664,63.091764034729515,63.091763754766781]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001}]
[null,null,"span length,m","400",0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(F6<67,(F6/1.03),65)*$E6+F8","v":2.432550134124114},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(G6<67,(G6/1.03),65)*$E6+G8","v":2.6985115804558482},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(H6<67,(H6/1.03),65)*$E6+H8","v":2.7311868939777031},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(I6<67,(I6/1.03),65)*$E6+I8","v":2.7352566847697659},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(J6<67,(J6/1.03),65)*$E6+J8","v":2.7357644485588684},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(K6<67,(K6/1.03),65)*$E6+K8","v":2.7358278126628499},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(L6<67,(L6/1.03),65)*$E6+L8","v":2.7358357201107824},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(M6<67,(M6/1.03),65)*$E6+M8","v":2.7358367069145877},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(N6<67,(N6/1.03),65)*$E6+N8","v":2.7358368300620501},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(O6<67,(O6/1.03),65)*$E6+O8","v":2.7358368454301485}]
[null,null,"amplifier","LEX","1",{"$f":"F9+F8*F7","v":64.260025697082426},{"$f":"G9+G8*G7","v":58.083127587925873},57.408369308221019,57.32547304290587,57.315148142581265,57.313859966183898,57.313699213997673,57.313679153120056,57.313676649638467,57.313676337218304]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001}]
[null,null,"span length,m","74",0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(F9<67,(F9/1.03),65)*$E9+F11","v":1.9516913161451019},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(G9<67,(G9/1.03),65)*$E9+G11","v":2.1665154348759845},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(H9<67,(H9/1.03),65)*$E9+H11","v":2.1929378481965847},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(I9<67,(I9/1.03),65)*$E9+I11","v":2.1962292967729402},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(J9<67,(J9/1.03),65)*$E9+J11","v":2.1966399587620185},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(K9<67,(K9/1.03),65)*$E9+K11","v":2.1966912055972729},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(L9<67,(L9/1.03),65)*$E9+L11","v":2.1966976008868651},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(M9<67,(M9/1.03),65)*$E9+M11","v":2.1966983989820763},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(N9<67,(N9/1.03),65)*$E9+N11","v":2.1966984985797877},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(O9<67,(O9/1.03),65)*$E9+O11","v":2.1966985110090116}]
[null,null,"amplifier","LEX","2",{"$f":"F12+F11*F10","v":63.497460866038217},{"$f":"G12+G11*G10","v":57.236626677211127},56.551544632173652,56.467362332070749,56.456876977893771,56.455568778332932,56.455405527379156,56.455385154669777,56.455382612273375,56.455382294996866]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002}]
[null,null,"span length,m","51",0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(F12<67,(F12/1.03),65)*$E12+F14","v":0.97842405227165963},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(G12<67,(G12/1.03),65)*$E12+G14","v":1.0867872330634589},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(H12<67,(H12/1.03),65)*$E12+H14","v":1.1001295013695667},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(I12<67,(I12/1.03),65)*$E12+I14","v":1.1017917766251193},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(J12<67,(J12/1.03),65)*$E12+J14","v":1.1019991761307304},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(K12<67,(K12/1.03),65)*$E12+K14","v":1.1020250577341377},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(L12<67,(L12/1.03),65)*$E12+L14","v":1.1020282875997811},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(M12<67,(M12/1.03),65)*$E12+M14","v":1.1020286906683754},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(N12<67,(N12/1.03),65)*$E12+N14","v":1.1020287409690277},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(O12<67,(O12/1.03),65)*$E12+O14","v":1.1020287472462611}]
[null,null,"amplifier","LEX","1",{"$f":"F15+F14*F13","v":63.233990837242501},{"$f":"G15+G14*G13","v":56.943976611091799},56.255301760044858,56.17067184246114,56.16013063974529,56.15881547078628,56.158651350094289,56.1586308688466,56.158628312905236,56.158627993938396]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005}]
[null,null,"span length,m","55",0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(F15<67,(F15/1.03),65)*$E15+F17","v":0.48976281816525502},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(G15<67,(G15/1.03),65)*$E15+G17","v":0.54414862861479885},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(H15<67,(H15/1.03),65)*$E15+H17","v":0.55084793975244228},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(I15<67,(I15/1.03),65)*$E15+I17","v":0.55168263627758052},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(J15<67,(J15/1.03),65)*$E15+J17","v":0.55178678082459043},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(K15<67,(K15/1.03),65)*$E15+K17","v":0.55179977714441231},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(L15<67,(L15/1.03),65)*$E15+L17","v":0.55180139900573866},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(M15<67,(M15/1.03),65)*$E15+M17","v":0.55180160140467605},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(N15<67,(N15/1.03),65)*$E15+N17","v":0.55180162666290433},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(O15<67,(O15/1.03),65)*$E15+O17","v":0.5518016298149867}]
[null,null,"amplifier","LEX","1",{"$f":"F18+F17*F16","v":63.09176371484731},{"$f":"G18+G17*G16","v":56.785955849342059},56.095335518340747,56.010463204886129,55.999891758593826,55.998572815503543,55.99840822382302,55.998387683798683,55.998385120522329,55.998384800640125]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(F18<67,(F18/1.03),65)*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(G18<67,(G18/1.03),65)*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(H18<67,(H18/1.03),65)*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(I18<67,(I18/1.03),65)*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(J18<67,(J18/1.03),65)*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(K18<67,(K18/1.03),65)*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(L18<67,(L18/1.03),65)*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(M18<67,(M18/1.03),65)*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(N18<67,(N18/1.03),65)*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(O18<67,(O18/1.03),65)*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":63.09176371484731},{"$f":"G21+G20*G19","v":56.785955849342059},56.095335518340747,56.010463204886129,55.999891758593826,55.998572815503543,55.99840822382302,55.998387683798683,55.998385120522329,55.998384800640125]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(F21<67,(F21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(G21<67,(G21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(H21<67,(H21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(I21<67,(I21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(J21<67,(J21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(K21<67,(K21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(L21<67,(L21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(M21<67,(M21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(N21<67,(N21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(O21<67,(O21/1.03),65)","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":63.09176371484731},{"$f":"F21-(F3-$B$2)","v":56.785955849342059},56.095335518340747,56.010463204886129,55.999891758593826,55.998572815503543,55.99840822382302,55.998387683798683,55.998385120522329,55.998384800640125]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":55.998384800640125}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net32"]

{"sheet":"Net31","index":5,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M11","v":63.09176371484731},"U start, V",{"$f":"+O5*1","v":0.49699781349123329},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":63.996845402816703},{"$f":"G6+G5*G4","v":63.10493651704865},63.091958266914908,63.091766588848174,63.091763757303333,63.091763715474492,63.091763714856576,63.091763714847445,63.09176371484731,63.09176371484731]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001}]
[null,null,"span length,m","350",0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(F6<67,(F6/1.03),65)*$E6+F8","v":0.48976281816525502},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(G6<67,(G6/1.03),65)*$E6+G8","v":0.49689095788459348},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(H6<67,(H6/1.03),65)*$E6+H8","v":0.49699623497744971},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(I6<67,(I6/1.03),65)*$E6+I8","v":0.49699779017272305},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(J6<67,(J6/1.03),65)*$E6+J8","v":0.49699781314676184},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(K6<67,(K6/1.03),65)*$E6+K8","v":0.49699781348614458},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(L6<67,(L6/1.03),65)*$E6+L8","v":0.49699781349115818},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(M6<67,(M6/1.03),65)*$E6+M8","v":0.49699781349123223},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(N6<67,(N6/1.03),65)*$E6+N8","v":0.49699781349123329},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(O6<67,(O6/1.03),65)*$E6+O8","v":0.49699781349123329}]
[null,null,"amplifier","LEX","1",{"$f":"F9+F8*F7","v":63.09176371484731},{"$f":"G9+G8*G7","v":62.186682026877918},62.173509224676579,62.173314672608981,62.173311798608118,62.173311756152096,62.173311755524914,62.173311755515648,62.173311755515513,62.173311755515513]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(F9<67,(F9/1.03),65)*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(G9<67,(G9/1.03),65)*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(H9<67,(H9/1.03),65)*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(I9<67,(I9/1.03),65)*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(J9<67,(J9/1.03),65)*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(K9<67,(K9/1.03),65)*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(L9<67,(L9/1.03),65)*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(M9<67,(M9/1.03),65)*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(N9<67,(N9/1.03),65)*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(O9<67,(O9/1.03),65)*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":63.09176371484731},{"$f":"G12+G11*G10","v":62.186682026877918},62.173509224676579,62.173314672608981,62.173311798608118,62.173311756152096,62.173311755524914,62.173311755515648,62.173311755515513,62.173311755515513]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(F12<67,(F12/1.03),65)*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(G12<67,(G12/1.03),65)*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(H12<67,(H12/1.03),65)*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(I12<67,(I12/1.03),65)*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(J12<67,(J12/1.03),65)*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(K12<67,(K12/1.03),65)*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(L12<67,(L12/1.03),65)*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(M12<67,(M12/1.03),65)*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(N12<67,(N12/1.03),65)*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(O12<67,(O12/1.03),65)*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":63.09176371484731},{"$f":"G15+G14*G13","v":62.186682026877918},62.173509224676579,62.173314672608981,62.173311798608118,62.173311756152096,62.173311755524914,62.173311755515648,62.173311755515513,62.173311755515513]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(F15<67,(F15/1.03),65)*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(G15<67,(G15/1.03),65)*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(H15<67,(H15/1.03),65)*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(I15<67,(I15/1.03),65)*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(J15<67,(J15/1.03),65)*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(K15<67,(K15/1.03),65)*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(L15<67,(L15/1.03),65)*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(M15<67,(M15/1.03),65)*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(N15<67,(N15/1.03),65)*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(O15<67,(O15/1.03),65)*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":63.09176371484731},{"$f":"G18+G17*G16","v":62.186682026877918},62.173509224676579,62.173314672608981,62.173311798608118,62.173311756152096,62.173311755524914,62.173311755515648,62.173311755515513,62.173311755515513]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(F18<67,(F18/1.03),65)*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(G18<67,(G18/1.03),65)*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(H18<67,(H18/1.03),65)*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(I18<67,(I18/1.03),65)*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(J18<67,(J18/1.03),65)*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(K18<67,(K18/1.03),65)*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(L18<67,(L18/1.03),65)*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(M18<67,(M18/1.03),65)*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(N18<67,(N18/1.03),65)*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(O18<67,(O18/1.03),65)*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":63.09176371484731},{"$f":"G21+G20*G19","v":62.186682026877918},62.173509224676579,62.173314672608981,62.173311798608118,62.173311756152096,62.173311755524914,62.173311755515648,62.173311755515513,62.173311755515513]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(F21<67,(F21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(G21<67,(G21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(H21<67,(H21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(I21<67,(I21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(J21<67,(J21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(K21<67,(K21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(L21<67,(L21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(M21<67,(M21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(N21<67,(N21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(O21<67,(O21/1.03),65)","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":63.09176371484731},{"$f":"F21-(F3-$B$2)","v":62.186682026877918},62.173509224676579,62.173314672608981,62.173311798608118,62.173311756152096,62.173311755524914,62.173311755515648,62.173311755515513,62.173311755515513]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":62.173311755515513}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net31"]

{"sheet":"Net22","index":6,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M10","v":62.21690559020071},"U start, V",{"$f":"+O5*1","v":0.49846296341791985},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":62.442424231266166},{"$f":"G6+G5*G4","v":62.217726005099799},62.216908585687669,62.216905601137938,62.216905590240643,62.216905590200852,62.21690559020071,62.21690559020071,62.21690559020071,62.21690559020071]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004}]
[null,null,"span length,m","86",0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(F6<67,(F6/1.03),65)*$E6+F8","v":0.49664957951343069},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(G6<67,(G6/1.03),65)*$E6+G8","v":0.4984563424166305},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(H6<67,(H6/1.03),65)*$E6+H8","v":0.49846293924309498},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(I6<67,(I6/1.03),65)*$E6+I8","v":0.49846296332965184},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(J6<67,(J6/1.03),65)*$E6+J8","v":0.49846296341759755},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(K6<67,(K6/1.03),65)*$E6+K8","v":0.49846296341791863},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(L6<67,(L6/1.03),65)*$E6+L8","v":0.49846296341791985},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(M6<67,(M6/1.03),65)*$E6+M8","v":0.49846296341791985},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(N6<67,(N6/1.03),65)*$E6+N8","v":0.49846296341791985},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(O6<67,(O6/1.03),65)*$E6+O8","v":0.49846296341791985}]
[null,null,"amplifier","LEX","1",{"$f":"F9+F8*F7","v":62.21690559020071},{"$f":"G9+G8*G7","v":61.991386949135254},61.990566534236166,61.990563538749207,61.990563527811979,61.990563527772046,61.990563527771904,61.990563527771904,61.990563527771904,61.990563527771904]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(F9<67,(F9/1.03),65)*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(G9<67,(G9/1.03),65)*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(H9<67,(H9/1.03),65)*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(I9<67,(I9/1.03),65)*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(J9<67,(J9/1.03),65)*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(K9<67,(K9/1.03),65)*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(L9<67,(L9/1.03),65)*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(M9<67,(M9/1.03),65)*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(N9<67,(N9/1.03),65)*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(O9<67,(O9/1.03),65)*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":62.21690559020071},{"$f":"G12+G11*G10","v":61.991386949135254},61.990566534236166,61.990563538749207,61.990563527811979,61.990563527772046,61.990563527771904,61.990563527771904,61.990563527771904,61.990563527771904]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(F12<67,(F12/1.03),65)*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(G12<67,(G12/1.03),65)*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(H12<67,(H12/1.03),65)*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(I12<67,(I12/1.03),65)*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(J12<67,(J12/1.03),65)*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(K12<67,(K12/1.03),65)*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(L12<67,(L12/1.03),65)*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(M12<67,(M12/1.03),65)*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(N12<67,(N12/1.03),65)*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(O12<67,(O12/1.03),65)*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":62.21690559020071},{"$f":"G15+G14*G13","v":61.991386949135254},61.990566534236166,61.990563538749207,61.990563527811979,61.990563527772046,61.990563527771904,61.990563527771904,61.990563527771904,61.990563527771904]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(F15<67,(F15/1.03),65)*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(G15<67,(G15/1.03),65)*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(H15<67,(H15/1.03),65)*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(I15<67,(I15/1.03),65)*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(J15<67,(J15/1.03),65)*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(K15<67,(K15/1.03),65)*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(L15<67,(L15/1.03),65)*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(M15<67,(M15/1.03),65)*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(N15<67,(N15/1.03),65)*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(O15<67,(O15/1.03),65)*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":62.21690559020071},{"$f":"G18+G17*G16","v":61.991386949135254},61.990566534236166,61.990563538749207,61.990563527811979,61.990563527772046,61.990563527771904,61.990563527771904,61.990563527771904,61.990563527771904]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(F18<67,(F18/1.03),65)*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(G18<67,(G18/1.03),65)*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(H18<67,(H18/1.03),65)*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(I18<67,(I18/1.03),65)*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(J18<67,(J18/1.03),65)*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(K18<67,(K18/1.03),65)*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(L18<67,(L18/1.03),65)*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(M18<67,(M18/1.03),65)*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(N18<67,(N18/1.03),65)*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(O18<67,(O18/1.03),65)*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":62.21690559020071},{"$f":"G21+G20*G19","v":61.991386949135254},61.990566534236166,61.990563538749207,61.990563527811979,61.990563527772046,61.990563527771904,61.990563527771904,61.990563527771904,61.990563527771904]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(F21<67,(F21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(G21<67,(G21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(H21<67,(H21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(I21<67,(I21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(J21<67,(J21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(K21<67,(K21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(L21<67,(L21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(M21<67,(M21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(N21<67,(N21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(O21<67,(O21/1.03),65)","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":62.21690559020071},{"$f":"F21-(F3-$B$2)","v":61.991386949135254},61.990566534236166,61.990563538749207,61.990563527811979,61.990563527772046,61.990563527771904,61.990563527771904,61.990563527771904,61.990563527771904]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":61.990563527771904}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net22"]

{"sheet":"Net21","index":7,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M9","v":62.21690559020071},"U start, V",{"$f":"+O5*1","v":0.49869586025072199},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":62.471150442945223},{"$f":"G6+G5*G4","v":62.217948806298566},62.216909888355495,62.216905607909837,62.216905590273676,62.216905590201016,62.21690559020071,62.21690559020071,62.21690559020071,62.21690559020071]
[null,null,"cable type","QR860",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004}]
[null,null,"span length,m","216",0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(F6<67,(F6/1.03),65)*$E6+F8","v":0.49664957951343069},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(G6<67,(G6/1.03),65)*$E6+G8","v":0.49868742936858856},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(H6<67,(H6/1.03),65)*$E6+H8","v":0.49869582551405611},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(I6<67,(I6/1.03),65)*$E6+I8","v":0.49869586010760097},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(J6<67,(J6/1.03),65)*$E6+J8","v":0.49869586025013229},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(K6<67,(K6/1.03),65)*$E6+K8","v":0.49869586025071949},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(L6<67,(L6/1.03),65)*$E6+L8","v":0.49869586025072199},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(M6<67,(M6/1.03),65)*$E6+M8","v":0.49869586025072199},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(N6<67,(N6/1.03),65)*$E6+N8","v":0.49869586025072199},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(O6<67,(O6/1.03),65)*$E6+O8","v":0.49869586025072199}]
[null,null,"amplifier","LEX","1",{"$f":"F9+F8*F7","v":62.21690559020071},{"$f":"G9+G8*G7","v":61.962660737456197},61.961617521358342,61.961613223203557,61.96161320549443,61.961613205421465,61.961613205421159,61.961613205421159,61.961613205421159,61.961613205421159]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(F9<67,(F9/1.03),65)*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(G9<67,(G9/1.03),65)*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(H9<67,(H9/1.03),65)*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(I9<67,(I9/1.03),65)*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(J9<67,(J9/1.03),65)*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(K9<67,(K9/1.03),65)*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(L9<67,(L9/1.03),65)*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(M9<67,(M9/1.03),65)*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(N9<67,(N9/1.03),65)*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(O9<67,(O9/1.03),65)*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":62.21690559020071},{"$f":"G12+G11*G10","v":61.962660737456197},61.961617521358342,61.961613223203557,61.96161320549443,61.961613205421465,61.961613205421159,61.961613205421159,61.961613205421159,61.961613205421159]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(F12<67,(F12/1.03),65)*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(G12<67,(G12/1.03),65)*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(H12<67,(H12/1.03),65)*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(I12<67,(I12/1.03),65)*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(J12<67,(J12/1.03),65)*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(K12<67,(K12/1.03),65)*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(L12<67,(L12/1.03),65)*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(M12<67,(M12/1.03),65)*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(N12<67,(N12/1.03),65)*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(O12<67,(O12/1.03),65)*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":62.21690559020071},{"$f":"G15+G14*G13","v":61.962660737456197},61.961617521358342,61.961613223203557,61.96161320549443,61.961613205421465,61.961613205421159,61.961613205421159,61.961613205421159,61.961613205421159]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(F15<67,(F15/1.03),65)*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(G15<67,(G15/1.03),65)*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(H15<67,(H15/1.03),65)*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(I15<67,(I15/1.03),65)*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(J15<67,(J15/1.03),65)*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(K15<67,(K15/1.03),65)*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(L15<67,(L15/1.03),65)*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(M15<67,(M15/1.03),65)*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(N15<67,(N15/1.03),65)*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(O15<67,(O15/1.03),65)*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":62.21690559020071},{"$f":"G18+G17*G16","v":61.962660737456197},61.961617521358342,61.961613223203557,61.96161320549443,61.961613205421465,61.961613205421159,61.961613205421159,61.961613205421159,61.961613205421159]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(F18<67,(F18/1.03),65)*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(G18<67,(G18/1.03),65)*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(H18<67,(H18/1.03),65)*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(I18<67,(I18/1.03),65)*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(J18<67,(J18/1.03),65)*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(K18<67,(K18/1.03),65)*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(L18<67,(L18/1.03),65)*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(M18<67,(M18/1.03),65)*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(N18<67,(N18/1.03),65)*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(O18<67,(O18/1.03),65)*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":62.21690559020071},{"$f":"G21+G20*G19","v":61.962660737456197},61.961617521358342,61.961613223203557,61.96161320549443,61.961613205421465,61.961613205421159,61.961613205421159,61.961613205421159,61.961613205421159]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(F21<67,(F21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(G21<67,(G21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(H21<67,(H21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(I21<67,(I21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(J21<67,(J21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(K21<67,(K21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(L21<67,(L21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(M21<67,(M21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(N21<67,(N21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(O21<67,(O21/1.03),65)","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":62.21690559020071},{"$f":"F21-(F3-$B$2)","v":61.962660737456197},61.961617521358342,61.961613223203557,61.96161320549443,61.961613205421465,61.961613205421159,61.961613205421159,61.961613205421159,61.961613205421159]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":61.961613205421159}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net21"]

{"sheet":"Net12","index":8,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M8","v":61.801887044733476},"U start, V",{"$f":"+O5*1","v":1.0098477128653189},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":62.542652220563568},{"$f":"G6+G5*G4","v":61.810847791876888},61.801996764748409,61.801888388400734,61.801887061188488,61.801887044934993,61.801887044735949,61.801887044733498,61.801887044733476,61.801887044733476]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004}]
[null,null,"span length,m","86",0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(F6<67,(F6/1.03),65)*$E6+F8","v":0.99765231287074274},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(G6<67,(G6/1.03),65)*$E6+G8","v":1.0096983907463437},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(H6<67,(H6/1.03),65)*$E6+H8","v":1.0098458842184277},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(I6<67,(I6/1.03),65)*$E6+I8","v":1.0098476904710696},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(J6<67,(J6/1.03),65)*$E6+J8","v":1.0098477125910714},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(K6<67,(K6/1.03),65)*$E6+K8","v":1.0098477128619607},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(L6<67,(L6/1.03),65)*$E6+L8","v":1.0098477128652781},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(M6<67,(M6/1.03),65)*$E6+M8","v":1.0098477128653187},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(N6<67,(N6/1.03),65)*$E6+N8","v":1.0098477128653189},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(O6<67,(O6/1.03),65)*$E6+O8","v":1.0098477128653189}]
[null,null,"amplifier","LEX","1",{"$f":"F9+F8*F7","v":62.089638258335221},{"$f":"G9+G8*G7","v":61.352363946606786},61.343445945642507,61.343336749111629,61.343335411855136,61.343335395478633,61.343335395278082,61.343335395275616,61.343335395275595,61.343335395275595]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003}]
[null,null,"span length,m","109",0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(F9<67,(F9/1.03),65)*$E9+F11","v":0.4999847331139573},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(G9<67,(G9/1.03),65)*$E9+G11","v":0.50605031572039383},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(H9<67,(H9/1.03),65)*$E9+H11","v":0.50612458973195529},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(I9<67,(I9/1.03),65)*$E9+I11","v":0.50612549931642081},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(J9<67,(J9/1.03),65)*$E9+J11","v":0.50612551045551057},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(K9<67,(K9/1.03),65)*$E9+K11","v":0.50612551059192368},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(L9<67,(L9/1.03),65)*$E9+L11","v":0.50612551059359434},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(M9<67,(M9/1.03),65)*$E9+M11","v":0.50612551059361477},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(N9<67,(N9/1.03),65)*$E9+N11","v":0.50612551059361488},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(O9<67,(O9/1.03),65)*$E9+O11","v":0.50612551059361488}]
[null,null,"amplifier","LEX","1",{"$f":"F12+F11*F10","v":61.801887044733476},{"$f":"G12+G11*G10","v":61.061121868903385},61.052161121759973,61.05205140174504,61.052050058077782,61.05205004162277,61.052050041421253,61.052050041418781,61.052050041418759,61.052050041418759]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(F12<67,(F12/1.03),65)*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(G12<67,(G12/1.03),65)*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(H12<67,(H12/1.03),65)*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(I12<67,(I12/1.03),65)*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(J12<67,(J12/1.03),65)*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(K12<67,(K12/1.03),65)*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(L12<67,(L12/1.03),65)*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(M12<67,(M12/1.03),65)*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(N12<67,(N12/1.03),65)*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(O12<67,(O12/1.03),65)*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":61.801887044733476},{"$f":"G15+G14*G13","v":61.061121868903385},61.052161121759973,61.05205140174504,61.052050058077782,61.05205004162277,61.052050041421253,61.052050041418781,61.052050041418759,61.052050041418759]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(F15<67,(F15/1.03),65)*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(G15<67,(G15/1.03),65)*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(H15<67,(H15/1.03),65)*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(I15<67,(I15/1.03),65)*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(J15<67,(J15/1.03),65)*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(K15<67,(K15/1.03),65)*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(L15<67,(L15/1.03),65)*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(M15<67,(M15/1.03),65)*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(N15<67,(N15/1.03),65)*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(O15<67,(O15/1.03),65)*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":61.801887044733476},{"$f":"G18+G17*G16","v":61.061121868903385},61.052161121759973,61.05205140174504,61.052050058077782,61.05205004162277,61.052050041421253,61.052050041418781,61.052050041418759,61.052050041418759]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(F18<67,(F18/1.03),65)*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(G18<67,(G18/1.03),65)*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(H18<67,(H18/1.03),65)*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(I18<67,(I18/1.03),65)*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(J18<67,(J18/1.03),65)*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(K18<67,(K18/1.03),65)*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(L18<67,(L18/1.03),65)*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(M18<67,(M18/1.03),65)*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(N18<67,(N18/1.03),65)*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(O18<67,(O18/1.03),65)*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":61.801887044733476},{"$f":"G21+G20*G19","v":61.061121868903385},61.052161121759973,61.05205140174504,61.052050058077782,61.05205004162277,61.052050041421253,61.052050041418781,61.052050041418759,61.052050041418759]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(F21<67,(F21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(G21<67,(G21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(H21<67,(H21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(I21<67,(I21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(J21<67,(J21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(K21<67,(K21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(L21<67,(L21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(M21<67,(M21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(N21<67,(N21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(O21<67,(O21/1.03),65)","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":61.801887044733476},{"$f":"F21-(F3-$B$2)","v":61.061121868903385},61.052161121759973,61.05205140174504,61.052050058077782,61.05205004162277,61.052050041421253,61.052050041418781,61.052050041418759,61.052050041418759]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":61.052050041418759}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net12"]

{"sheet":"Net11","index":9,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M7","v":61.801887044733476},"U start, V",{"$f":"+O5*1","v":1.0055835398607509},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":62.337329430994643},{"$f":"G6+G5*G4","v":61.806558464594417},61.801928158513441,61.801887406609012,61.80188704791864,61.801887044761514,61.801887044733718,61.801887044733476,61.801887044733476,{"$f":"O6+O5*O4","v":61.801887044733476}]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784}]
[null,null,"span length,m","28",0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(F6<67,(F6/1.03),65)*$E6+F8","v":0.99684953874082027},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(G6<67,(G6/1.03),65)*$E6+G8","v":1.0055066752847879},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(H6<67,(H6/1.03),65)*$E6+H8","v":1.0055828633139656},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(I6<67,(I6/1.03),65)*$E6+I8","v":1.0055835339059129},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(J6<67,(J6/1.03),65)*$E6+J8","v":1.0055835398083377},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(K6<67,(K6/1.03),65)*$E6+K8","v":1.0055835398602895},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(L6<67,(L6/1.03),65)*$E6+L8","v":1.0055835398607469},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(M6<67,(M6/1.03),65)*$E6+M8","v":1.0055835398607509},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(N6<67,(N6/1.03),65)*$E6+N8","v":1.0055835398607509},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(O6<67,(O6/1.03),65)*$E6+O8","v":1.0055835398607509}]
[null,null,"amplifier","LEX","1",{"$f":"F9+F8*F7","v":62.189955195187203},{"$f":"G9+G8*G7","v":61.657904357720312},61.653262788001101,61.653221936956363,61.653221577393374,61.653221574228567,61.653221574200707,61.653221574200465,61.653221574200465,{"$f":"O9+O8*O7","v":61.653221574200465}]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007}]
[null,null,"span length,m","147",0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(F9<67,(F9/1.03),65)*$E9+F11","v":0.4999847331139573},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(G9<67,(G9/1.03),65)*$E9+G11","v":0.5043543847248031},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(H9<67,(H9/1.03),65)*$E9+H11","v":0.5043928434726519},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(I9<67,(I9/1.03),65)*$E9+I11","v":0.50439318197918226},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(J9<67,(J9/1.03),65)*$E9+J11","v":0.50439318495865326},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(K9<67,(K9/1.03),65)*$E9+K11","v":0.50439318498487795},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(L9<67,(L9/1.03),65)*$E9+L11","v":0.50439318498510888},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(M9<67,(M9/1.03),65)*$E9+M11","v":0.50439318498511077},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(N9<67,(N9/1.03),65)*$E9+N11","v":0.50439318498511077},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(O9<67,(O9/1.03),65)*$E9+O11","v":0.50439318498511077}]
[null,null,"amplifier","LEX","1",{"$f":"F12+F11*F10","v":61.801887044733476},{"$f":"G12+G11*G10","v":61.266444658472309},61.261773238611369,61.261732124831404,61.261731762955868,61.261731759770704,61.261731759742666,61.261731759742425,61.261731759742425,{"$f":"O12+O11*O10","v":61.261731759742425}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(F12<67,(F12/1.03),65)*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(G12<67,(G12/1.03),65)*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(H12<67,(H12/1.03),65)*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(I12<67,(I12/1.03),65)*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(J12<67,(J12/1.03),65)*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(K12<67,(K12/1.03),65)*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(L12<67,(L12/1.03),65)*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(M12<67,(M12/1.03),65)*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(N12<67,(N12/1.03),65)*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(O12<67,(O12/1.03),65)*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":61.801887044733476},{"$f":"G15+G14*G13","v":61.266444658472309},61.261773238611369,61.261732124831404,61.261731762955868,61.261731759770704,61.261731759742666,61.261731759742425,61.261731759742425,{"$f":"O15+O14*O13","v":61.261731759742425}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(F15<67,(F15/1.03),65)*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(G15<67,(G15/1.03),65)*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(H15<67,(H15/1.03),65)*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(I15<67,(I15/1.03),65)*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(J15<67,(J15/1.03),65)*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(K15<67,(K15/1.03),65)*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(L15<67,(L15/1.03),65)*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(M15<67,(M15/1.03),65)*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(N15<67,(N15/1.03),65)*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(O15<67,(O15/1.03),65)*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":61.801887044733476},{"$f":"G18+G17*G16","v":61.266444658472309},61.261773238611369,61.261732124831404,61.261731762955868,61.261731759770704,61.261731759742666,61.261731759742425,61.261731759742425,{"$f":"O18+O17*O16","v":61.261731759742425}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(F18<67,(F18/1.03),65)*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(G18<67,(G18/1.03),65)*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(H18<67,(H18/1.03),65)*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(I18<67,(I18/1.03),65)*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(J18<67,(J18/1.03),65)*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(K18<67,(K18/1.03),65)*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(L18<67,(L18/1.03),65)*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(M18<67,(M18/1.03),65)*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(N18<67,(N18/1.03),65)*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(O18<67,(O18/1.03),65)*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":61.801887044733476},{"$f":"G21+G20*G19","v":61.266444658472309},61.261773238611369,61.261732124831404,61.261731762955868,61.261731759770704,61.261731759742666,61.261731759742425,61.261731759742425,{"$f":"O21+O20*O19","v":61.261731759742425}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(F21<67,(F21/1.03),65)+F23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(G21<67,(G21/1.03),65)+G23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(H21<67,(H21/1.03),65)+H23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(I21<67,(I21/1.03),65)+I23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(J21<67,(J21/1.03),65)+J23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(K21<67,(K21/1.03),65)+K23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(L21<67,(L21/1.03),65)+L23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(M21<67,(M21/1.03),65)+M23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(N21<67,(N21/1.03),65)+N23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(O21<67,(O21/1.03),65)+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":61.801887044733476},{"$f":"F21-(F3-$B$2)","v":61.266444658472309},61.261773238611369,61.261732124831404,61.261731762955868,61.261731759770704,61.261731759742666,61.261731759742425,61.261731759742425,61.261731759742425]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":61.261731759742425}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net11"]

{"sheet":"AUX","index":10,"n_rows":13,"n_cols":27,"rows_kept":13,"cut":false,"hidden":true,"merged":[[1,3,1,5],[1,7,1,9]]}
[]
[null,null,null,"R,Ohm",null,null,null,"Vdrop,V"]
[null,"length,m","I,A",540,860,750,"3x10",540,860,750,"3x10","amp type","Inom,A","Vnom,V","Pnom,W","factor_i","cable","loop_res",null,null,null,null,null,null,null,null,"LIST"]
[1,null,null,{"$f":"B4*$R$4","v":0},{"$f":"B4*$R$5","v":0},{"$f":"B4*$R$6","v":0},{"$f":"+B4*$R$7","v":0},{"$f":"$C4*D4","v":0},{"$f":"$C4*E4","v":0},{"$f":"$C4*F4","v":0},{"$f":"$C4*G4","v":0},"HLN",1.4,60,84,{"$f":"M4/(O4/N4)","v":1},"QR540",{"$f":"S4/1000","v":5.28E-3},5.28,"C500",{"$f":"V4/1000","v":5.64E-3},5.64,null,null,null,null,"Net11"]
[2,null,null,0,0,0,{"$f":"+B5*$R$7","v":0},{"$f":"$C5*D5","v":0},{"$f":"$C5*E5","v":0},{"$f":"$C5*F5","v":0},{"$f":"$C5*G5","v":0},"TNA",1,60,60,{"$f":"M5/(O5/N5)","v":1},"QR860",{"$f":"S5/1000","v":2.3700000000000001E-3},2.37,"C625",{"$f":"V5/1000","v":3.6099999999999999E-3},3.61,null,null,null,null,"Net12"]
[3,null,null,0,0,0,{"$f":"+B6*$R$7","v":0},0,0,0,0,"LEX",0.5,60,36,{"$f":"M6/(O6/N6)","v":0.83333333333333337},"C750",{"$f":"S6/1000","v":2.49E-3},2.4900000000000002,null,null,null,null,null,null,null,"Net21"]
[4,null,null,0,0,0,0,0,0,0,0,"DBLE",0.6,60,24,{"$f":"M7/(O7/N7)","v":1.4999999999999998},"3x10",{"$f":"+S7/1000","v":2.5000000000000001E-3},2.5,null,null,null,null,null,null,null,"Net22"]
[5,null,null,0,0,0,0,{"$f":"$C8*D8","v":0},{"$f":"$C8*E8","v":0},0,0,"GNA",1,60,60,{"$f":"M8/(O8/N8)","v":1},"C500",{"$f":"S8/1000","v":5.64E-3},5.64,null,null,null,null,null,null,null,"Net31"]
[6,null,null,0,0,0,0,{"$f":"$C9*D9","v":0},{"$f":"$C9*E9","v":0},0,0,null,null,null,null,null,"C625",3.6099999999999999E-3,3.61,null,null,null,null,null,null,null,"Net32"]
[7,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,"2x10",3.6600000000000001E-3,3.66,null,null,null,null,null,null,null,"Net41"]
[8,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,"2x6",6.0000000000000001E-3,6,null,null,null,null,null,null,null,"Net42"]
[9,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,"4x10",1.83E-3,1.83]
[10,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,"4x6",3.0000000000000001E-3,3]

{"sheet":"specs","index":11,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[19,10,20,13],[21,3,21,4],[21,5,21,6]]}
[]
[]
[null,null,null,1,2,3,4,5,null,null,1,2]
[null,null,"amp type","sorted","Inom,A","Vnom,V","Pnom,W",null,"original","cable","sorted","loop_res",null,null,"original"]
[null,null,"load","DBLE",null,60,30,1,30,"cable","2x10",3.66,"cable",1,3.66]
[null,null,"HLN","future1",null,60,0,1,0,"QR860","2x6",6,"QR860",2,6]
[null,null,"TNA","future2",null,60,0,1,0,"C750","3x10",2.5,"C750",3,2.5]
[null,null,"GNA","future3",null,60,0,1,0,"QR715 ","4x10",1.83,"QR715 ",4,1.83]
[null,null,"LEX","future4",null,60,0,1,0,"C625","4x6",3,"C625",5,3]
[null,null,"DBLE","future5",null,60,0,1,0,"C565 ","C500",5.64,"C565 ",6,5.64]
[null,null,"future1","future6",null,60,0,1,0,"QR540","C565 ",4.26,"QR540",7,4.26]
[null,null,"future2","future7",null,60,0,1,0,"C500","C625",3.61,"C500",8,3.61]
[null,null,"future3","GNA",null,60,48,1,48,"QR1125","C750",2.4900000000000002,"QR1125",9,2.4900000000000002]
[null,null,"future4","HLN",null,60,84,1,84,"3x10","cable",0,"2x10",10,0]
[null,null,"future5","LEX",null,60,30,1,24,"4x10","QR1125",1.3,"2x6",11,1.3]
[null,null,"future6","load",null,1,0,0,0,"2x10","QR540",5.28,"3x10",12,5.28]
[null,null,"future7","TNA",null,60,52,1,52,"2x6","QR715 ",3.27,"4x10",13,3.27]
[null,null,null,null,null,null,null,null,null,"4x6","QR860",2.37,"4x6",14,2.37]
[null,null,null,null,null,"Range $D$5:$H$17",null,null,null,"type","spare",0,null,null,0]
[]
[]
[null,null,null,"Efficiency",null,"tangens alpha",null,null,null,null,"Range $K$5:$L$19",null,"Cable \ntype","ρ (Ω/Km)"]
[null,null,"Load,%","Super2M-90","T-former","Super2M-90","T-former","load span","SpanN",null,null,null,"QR-540 ",5.28]
[null,"L0",4,36.55806621,62.083720929999998,{"$f":"(D25-D24)/($C25-$C24)","v":4.2606763124999993},{"$f":"+(E25-E24)/($C25-$C24)","v":3.4893378800000008},{"$f":"+C25-C24","v":4},1,null,null,null,"QR-715 ",3.27]
[null,"L1",8,53.600771459999997,76.041072450000001,{"$f":"(D26-D25)/($C26-$C25)","v":2.4445559925000016},1.5768140174999985,{"$f":"+C26-C25","v":4},2,null,null,null,"QR-860 ",2.37]
[null,"L2",12,63.378995430000003,82.348328519999995,1.4451867049999993,0.7958163650000003,8,3,null,null,null,"P3-500 ",5.64]
[null,"L3",20,74.940489069999998,88.714859439999998,0.7155390490000002,0.27130518400000059,10,4,null,null,null,"P3-565 ",4.26]
[null,"L4",30,82.09587956,91.427911280000004,0.48487377400000042,0.12942325799999993,10,5,null,null,null,"P3-625 ",3.61]
[null,"L5",40,86.944617300000004,92.722143860000003,0.17963340999999958,0.11173976900000042,10,6]
[null,"L6",50,88.7409514,93.839541550000007,0.11277000900000048,3.6879177999999513E-2,10,7]
[null,"L7",60,89.868651490000005,94.208333330000002,8.9180478000000105E-2,3.8966666999999691E-2,10,8]
[null,"L8",70,90.760456270000006,94.597999999999999,5.1471151999999167E-2,-5.6377240000003324E-3,10,9]
[null,"L9",80,91.275167789999998,94.541622759999996,4.0063600000053159E-4,-3.8172269999999744E-2,10,10]
[null,"L10",90,91.279174150000003,94.159900059999998,3.6039225000000383E-2,-8.7130945999999196E-2,10,11]
[null,"L11",100,91.639566400000007,93.288590600000006]